DELETE FROM [AppDB].[User].[AddressType]
INSERT
INTO [AppDB].[User].[AddressType]
	([Name])
SELECT
	[Name]
FROM [AdventureWorks2008R2].[Person].[AddressType]
GO

DELETE FROM [AppDB].[User].[ContactType]
INSERT
INTO [AppDB].[User].[ContactType]
	([Name])
SELECT
	[Name]
FROM [AdventureWorks2008R2].[Person].[ContactType]
GO

DELETE FROM [AppDB].[User].[CountryRegion]
INSERT
INTO [AppDB].[User].[CountryRegion]
	([CountryRegionCode], [Name])
SELECT
	[CountryRegionCode], [Name]
FROM [AdventureWorks2008R2].[Person].[CountryRegion]
GO


DELETE FROM [AppDB].[User].[PhoneNumberType]
INSERT
INTO [AppDB].[User].[PhoneNumberType]
	([Name])
SELECT
	[Name]
FROM [AdventureWorks2008R2].[Person].[PhoneNumberType]
GO


DELETE FROM [AppDB].[User].[StateProvince]
INSERT
INTO [AppDB].[User].[StateProvince]
	([StateProvinceCode], [CountryRegionCode], [IsOnlyStateProvinceFlag], [Name])
SELECT
	[StateProvinceCode], [CountryRegionCode], [IsOnlyStateProvinceFlag], [Name]
FROM [AdventureWorks2008R2].[Person].[StateProvince]

INSERT
INTO [AppDB].[User].[StateProvince]
	([StateProvinceCode], [CountryRegionCode], [IsOnlyStateProvinceFlag], [Name])
VALUES('WB', 'IN', 0, 'West Bengal')

INSERT
INTO [AppDB].[User].[StateProvince]
	([StateProvinceCode], [CountryRegionCode], [IsOnlyStateProvinceFlag], [Name])
VALUES('AP', 'IN', 0, 'Andhra Pradesh')
GO


DELETE FROM [AppDB].[User].[Role]
INSERT
INTO [AppDB].[User].[Role]
	([RoleName], [RoleDesc])
VALUES
	('SC', 'Store Contact')
INSERT
INTO [AppDB].[User].[Role]
	([RoleName], [RoleDesc])
VALUES
	('IN', 'Individual (retail) customer')
INSERT
INTO [AppDB].[User].[Role]
	([RoleName], [RoleDesc])
VALUES
	('SP', 'Sales person')
INSERT
INTO [AppDB].[User].[Role]
	([RoleName], [RoleDesc])
VALUES
	('EM', 'Employee (non-sales)')
INSERT
INTO [AppDB].[User].[Role]
	([RoleName], [RoleDesc])
VALUES
	('VC', 'Vendor contact')
INSERT
INTO [AppDB].[User].[Role]
	([RoleName], [RoleDesc])
VALUES
	('GC', 'General contact')
GO